Using Special Characters in a Filter

When setting up a filter, you can enter the following special characters in the Value column:

characters	description
_ (underscore)	Returns any single character.
[]	Returns any single character within the specified range. For example, [a–f]. – OR –   Returns any single character within the set range. For example, [abcdef].
[^]	Returns any single character not within the specified range. For example, [^a–f]. – OR –   Returns any single character not within the set range. For example, [^abcdef].
%	Returns any string of zero or more characters. For example, 51 % Street returns all street names that begin with the number 51.

You can only use the special characters with the following conditions: contains, does not contain, begins with, does not begin with, ends with, and does not end with.

For more information about special characters, see Basic Regular Expression Syntax.

Keep in mind the following when using these conditions:

condition	description
ends with	Automatically adds the % character to the beginning of the filter value.
begins with	Automatically adds a % character to the end of the filter value.
contains	Automatically adds a % character to the beginning and the end of the filter value.

If you want to filter on a special character, use brackets around the character. For example, [%], [_], [[].